Problem Note 46699: Using PROC DATASETS with SAS/ACCESS® Interface to Greenplum might result in a syntax error
A syntax error might occur when you use the DATASETS procedure (PROC) to change the name of a table with SAS/ACCESS Interface to Greenplum. For example, the following code could generate the error and the error message:
libname glib greenplm dsn=greenplum user=userid password=passwd1 schema=public;
proc datasets lib=glib;
delete curdata2;
change curdata1=curdata2;
quit;
ERROR: CLI execute error: [SAS ACCESS to Greenplum][ODBC Greenplum Wire Protocol
driver][Greenplum]ERROR: syntax error at or near "."(Position 63;File scan.l;Line
979;Routine base_yyerror;)
Workarounds
To work around this issue, do one of the following:
- If the default schema with which the user ID logs in to the Greenplum database is the same as the one needed for use with PROC DATASETS, omit the schema option from the LIBNAME statement.
- Use a different method such as PROC SQL or DATA Step code to create a new data set and delete the old one.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Greenplum | Microsoft® Windows® for x64 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Standard Edition | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Microsoft Windows Server 2003 for x64 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Microsoft Windows Server 2008 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Microsoft Windows Server 2008 for x64 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Microsoft Windows XP Professional | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Windows 7 Enterprise 32 bit | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Windows 7 Enterprise x64 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Windows 7 Home Premium 32 bit | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Windows 7 Home Premium x64 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Windows 7 Professional 32 bit | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Windows 7 Professional x64 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Windows 7 Ultimate 32 bit | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Windows 7 Ultimate x64 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Windows Vista | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Windows Vista for x64 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
64-bit Enabled AIX | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
64-bit Enabled Solaris | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
HP-UX IPF | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Linux | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Linux for x64 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
Solaris for x64 | 9.3_M1 | 9.31 | 9.3 TS1M1 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | medium |
Topic: | Data Management ==> Data Sources ==> External Databases ==> GreenPlum
|
Date Modified: | 2012-06-08 14:28:10 |
Date Created: | 2012-05-30 15:19:06 |